#ifndef __SSB_H__
#define __SSB_H__
	struct ddate{
		int datekey;
		char date[18];
		char dayofweek[8];
		char month[9];
		int year;
		int yearmonthnum;
		char yearmonth[7];
		char daynuminweek;	// this is represented in num, not char
		char daynuminmonth; 	// this is represented in num, not char
		int daynuminyear;
		char monthnuminyear; 	// this is represented in num, not char
		char weeknuminyear;	// this is represented in num, not char
		char sellingseason[12];
		char lastdayinweekfl;	// this is char
		char lastdayinmonthfl;	// this is char
		char holidayfl;		// this is char
		char weekdayfl;		// this is char
	};

	struct lineorder{
		int orderkey;
		char linenumber;	// this is number
		int custkey;
		int partkey;
		int suppkey;
		int orderdate;
		char orderpriority[16];
		char shippriority;
		char quantity;
		int extendedprice;
		int ordtotalprice;
		int discount;
		int revenue;
		int supplycost;
		char tax;
		int commitdate;
		char shipmode[10];
	};

	struct part {
		int partkey;
		char name[22];
		char mfgr[6];
		char category[7];
		char brand1[9];
		char color[11];
		char type[25];
		int size;
		char container[10];
	};

	struct supplier{
		int suppkey;
		char name[25];
		char address[25];
		char city[10];
		char nation[15];
		char region[12];
		char phone[15];
	};


	struct customer{
		int custkey;
		char name[25];
		char address[25];
		char city[10];
		char nation[15];
		char region[12];
		char phone[15];
		char mktsegment[10];
	};

#endif
